home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Home & Business Platinum
/
Home and Business Platinum.iso
/
database
/
stampb
/
sbguide.doc
< prev
next >
Wrap
Text File
|
1992-02-25
|
35KB
|
1,188 lines
STAMPBASE
FOR WINDOWS
Stamp Collection Inventory System
for Microsoft WindowsTM
USER'S GUIDE
STAMPBASE
FOR WINDOWS
USER'S GUIDE
Version 1.0
This product was developed with Microsoft Visual BasicTM.
(C) Copyright 1992 by Mark L. Hetzel
If you are an individual, (not a company or an institution) you may use the
program on any other computer(s) that you personally own. You may make backup
copies of the program only for your use. However, no part of this user guide
may be photocopied. I am relying primarily on your good faith not to violate
my copyright.
Microsoft, Windows and Visual Basic are trademarks of Microsoft Corporation.
The author warrants for a 90-day period commencing on the date you receive
delivery of a registered copy of the program, that, if properly installed and
operated on a computer for which it was designed, the program will perform
substantially in accordance with the User's Guide. The author's liability
shall, in any event, be limited to the purchase price of the program and shall
not include consequential damages, such as loss or destruction of data
resulting from use of the program. The author will not honor any warranty
unless you own a registered copy of the program.
Table of Contents
Chapter 1 - Getting Started
Introduction 1
Hardware and Software Requirements 1
System Files 1
Overview of StampBase Features 1
Installing StampBase 2
Chapter 2 - Using StampBase
Starting and Exiting StampBase 5
Working with the Menu Bar 5
Selecting Menu Commands 6
Using StampBase's Control Menu 6
Chapter 3 - Building a Database
Opening a Database File 8
Adding Records 10
Editing Records 11
Sorting Records 13
Pack Records 13
Saving Files 14
Chapter 4 - Database Reports
Types of Reports 15
Displaying and Printing Reports 15
Chapter 5 - Technical Support 18
CHAPTER 1 - GETTING STARTED
Introduction
Welcome to StampBase for WindowsTM. StampBase is stamp collection inventory
system developed specifically for Microsoft Windows 3.0. StampBase takes
advantage of Windows' Graphical User Interface (GUI) and its memory management
capabilities. StampBase is a Windows application, therefore the program will
not work outside the Windows environment. StampBase for Windows was developed
with Microsoft Visual BasicTM.
Hardware and Software Requirements
80286 PC or better
1 MB RAM
Hard Drive
Microsoft Windows 3.0 or better
System Files
Files included with StampBase:
README Basic information about program and a registration
form in ASCII text format.
SBGUIDE.DOC User's Guide in ASCII text format.
STAMPWIN.EXE StampBase for Windows application.
VBRUN100.DLL Visual Basic run time file required to use StampBase.
Overview of StampBase Features
* Create one or more database files. Each file is limited to 32,767
records.
* Intuitive data entry and edit features.
* Uses stamp numbering system used by most popular catalogs and
publications.
* Records sorted by country and catalog number.
* Easy record retrieval.
* Reports display records and collection statistics on screen or in
printed form.
1
* Mouse and keyboard supported.
Installing StampBase
StampBase files should be copied to your hard drive before attempting to run
the program. Windows' File Manager will help you create a directory and copy
the program files from the diskette to the new directory on the hard drive.
File Manager is in the first position in the Main Group window of Program
Manager.
Mouse * Double-click the File Manager program icon.
Keyboard * Press the left or right arrow key to move the highlight to the
File Manager program icon and press ENTER.
Create a New Directory:
Mouse 1. Point to File on the menu bar and click.
2. Point to the Create Directory menu item and click. The
Create Directory dialog box will appear.
3. Type the new directory name including the drive, if
different then the current one.
4. Point to the OK button and click to create directory.
Keyboard 1. Press ALT, F to open the File menu.
2. Press E to select Create Directory. The Create Directory
dialog box will appear.
3. Type the new directory name including the drive, if
different then the current one.
4. Press ENTER to create directory.
Copy StampBase Files to New Directory:
Make sure the source and destination disk drive icons are visible.
Mouse 1. Point to the source disk drive icon (A or B) and click.
2. Point to File on the menu bar and click.
3. Point to the Copy menu item and click. The Copy dialog box
will appear.
4. Type the destination disk drive and directory. Example:
C:\StampBas
2
5. Point to the OK button and click.
KeyBoard 1. Press CTRL and letter of disk drive containing the program
files.
2. Press F8. The Copy dialog box will appear.
3. Type the destination disk drive and directory. Example:
C:\StampBas
4. Press ENTER to begin copying files.
Exit File Manager:
Mouse 1. Point to File on the menu bar and click.
2. Point to Exit menu item and click. The Exit File Manager
dialog box will appear.
3. If an X appears in the Save Settings check box, point to the
OK button and click. Point to the Save Settings check box
and click if the box is empty.
Keyboard 1. Press ALT, F to open the File menu.
2. Press X. The Exit File Manager dialog box will appear.
3. If an X appears in the Save Settings check box, press the OK
button. If the Save Settings check box is empty, press S to
place an X in the box and press ENTER.
Add StampBase to Windows Application Group:
Mouse 1. Double-click the Windows Setup program icon. The Windows
Setup dialog box will appear.
2. Point to the Options menu item and click.
3. Point to Set Up Applications and click. The Setup
Applications will appear.
4. Point to the OK button and click. Windows will search your
hard drive(s) for applications to set up for use with
Windows.
5. Point to StampBase in the list box on the left and click.
6. Point to the Add-> button and click. StampBase will move
from the left list box to the one on the right.
7. Point to the OK button and click.
3
Keyboard 1. Press the direction arrow key(s) to move the highlight to
the Windows Setup Program icon and press ENTER. The Windows
Setup dialog box will appear.
2. Press ALT, O to open the Options menu.
3. Press S. The Set Up Applications dialog box will appear.
4. Press ENTER. The Windows Setup dialog box will appear.
Windows will search the hard drive(s) for applications to
set up for use with Windows.
5. Press TAB to highlight the left list box.
6. Use UP or DOWN arrow keys to move to StampBase then press
the SPACEBAR to select it.
7. Press ALT, A to move StampBase from the left list box to the
one on the right.
8. Press Tab to highlight the OK button and press ENTER.
9. Press ALT, SPACEBAR to open the Windows Setup control menu.
10. Press C to close the dialog box and exit from Windows Setup.
StampBase will now be included in the Windows Applications window with
its own program icon.
4
CHAPTER 2 - USING STAMPBASE
Starting and Exiting StampBase
Starting StampBase from Program Manager:
Mouse 1. Open the Program Manager window, if not already open, by
double-clicking the Program Manager icon.
2. Open the Windows Application Group window, if not already
open, by double-clicking the Windows Application Group icon.
3. Double-click the StampBase icon. The StampBase title page
will appear.
4. Point to the Continue button and click. The StampBase menu
bar will appear.
KeyBoard 1. Open the Program Manager window, if not already open, by
using direction keys to highlight the Program Manager icon
and press ENTER.
2. Open the Windows Applications Group window, if not already
open, by pressing CTRL, TAB to highlight the Windows
Applications Group icon and press ENTER.
3. Use the direction arrow keys to highlight the StampBase
program icon and press ENTER. The StampBase title page will
appear.
4. Press ENTER. The StampBase menu bar will appear.
Exiting StampBase:
Mouse 1. Point to File on the menu bar and click.
2. Point to the Exit menu item and click. The StampBase for
Windows order form will appear if you are using a review
copy.
Keyboard 1. Press ALT, F.
2. Press X. The StampBase for Windows order form will appear
if you are using a review copy.
Working the Menu Bar
Select a Menu:
Mouse * Point to the name of the menu item on the menu bar and click
to open the menu.
5
Keyboard * Press ALT and the underlined letter of the menu item you want.
Cancel a Menu:
Mouse * Click the menu name or any where outside the menu.
KeyBoard * Press ALT to cancel the menu and move back to the application
workspace.
Or press ESC to cancel the menu but remain on the menu bar so
that you can select another menu.
Selecting Menu Commands
Choose an Item from a Selected Menu:
Mouse * Point to the menu item and click.
Keyboard * Type the underlined letter in the item name.
Using StampBase's Control Menu
Open StampBase's Control Menu:
Mouse * Point to the Control Menu box in the upper-left corner of the
window and click.
Do not double-click or you will close the window.
Keyboard * Press ALT and SPACEBAR.
Control Menu Commands
Command Action
Restore Restores the window to its size before it was enlarged or
shrunk to an icon.
Move Allows window to be moved to another position of the screen.
Size Allows you to change the size of the window.
Minimize Shrinks the window to an icon.
Maximize Enlarges the window to full screen.
Close Closes window and exits from StampBase.
6
Switch To... Starts Task List, which lets you switch among running
applications.
Screen Color:
The background color of each StampBase screen can be changed through
Windows'Control Panel. The color of text, data entry fields and on
screen reports cannot be changed.
7
CHAPTER 3 - BUILDING A DATABASE
Opening a Database File
StampBase allows you to create one large database or several small database
files for your stamp collection. The StampBase Title Screen will appear
first. Point to the Continue button and click or press ENTER to display the
StampBase menu bar. Note: Only one database file can be open at a time.
Create a Database File:
Mouse 1. Point to File on the menu bar and click to open the menu.
2. Point to the Open File menu item and click. The File
Selection screen will appear.
3. Enter the file name to be created. The current drive and
path is displayed below the file name entry box. The file
name must have the extension .DAT. (Example: Postage.Dat)
Change the drive -
a. Point to the Drive List box arrow in the lower right hand
corner of screen and click. A list of the available
drives will appear.
b. Point to the appropriate drive and click. The new drive
will appear below the file name box.
Change the directory -
a. Point to the current drive in the Directory List box and
double-click.
b. Point to the new directory and double-click. The drive
and new directory will appear below the file name text
box.
4. Point to the OK button and click. The File Selection screen
will disappear when a proper file name is entered. Point to
the Cancel button and click to cancel your selection and
return to the menu bar.
Keyboard 1. Press ALT, F to open the menu.
2. Press O. The File Selection screen will appear.
3. Enter the file name to be created. The current drive and
path is displayed below the file name entry box. The file
name must have the extension .DAT. (Example: Postage.Dat)
8
Change the drive -
Type the drive letter followed by a colon and press ENTER.
(Example: B:)
Change the directory -
a. Press TAB to highlight the Directory List box.
b. Press the direction key(s) to highlight the new directory
and press ENTER. The drive and new directory will appear
below the file name text box.
4. Press TAB to highlight the OK button and press ENTER. The
File Selection screen will disappear when a proper file name
is entered. Press ALT, C to cancel your selection and
return to the menu bar.
Open an Existing Database File:
Mouse 1. Point to File on the menu bar and click to open the menu.
2. Point to the Open File menu item and click. The File
Selection screen will appear.
3. Point to the file listed in file list box and double-click.
The database file will be opened and the File Selection
screen will disappear.
Keyboard 1. Press ALT, F to open the menu.
2. Press O. The File Selection screen will appear. Follow the
instructions for Creating a Database File to change the
drive and directory.
3. Press TAB until the first item in the file list box is
highlighted.
4. Press the DOWN arrow to highlight the file to be opened and
press ENTER. The database file will be opened and File
Selection screen will disappear.
Adding Records
Mouse 1. Point to Records on the menu bar and click to open the menu.
2. Point to the Update menu item and click. If you have
already opened a database file, the Data Entry and Edit
Screen will appear.
9
If a file is not open, a menu dialog box will appear. Point
to the OK button and click. The dialog box will disappear.
See the instructions for Opening a Database File.
Keyboard 1. Press ALT, R to open the menu.
2. Press ENTER. If you have already opened a database file,
the Data Entry and Edit Screen will appear.
If a file is not open, a menu dialog box will appear. Press
ENTER. The dialog box will disappear. See the instructions
for Opening a Database File.
The following list is the data entry fields for each record stored in
the database:
Length
Field Description (Characters) Format
Country * Issuing stamp 25 Text
Catalog No. * Catalog number 6 Alpha/Numeric
Category Stamp type 20 Text
Issue Year Year issued 4 Numeric
Description Stamp description 35 Text
Stamp Grade Condition 6 Text
Purchase Date Date purchased 8 MM/DD/YR
Cost Purchase price 8 $0-$99,999.00
Market Value Catalog value 8 $0-$99,999.00
Comments Remarks 50 Text
* Fields must contain data before record can be stored in database file.
Enter Data:
Data entered does not become part of a record until the cursor is moved
to another field by pressing TAB, pointing to a field and clicking or
pressing SHIFT, TAB. Press TAB to move the cursor forward from field to
field and button to button. Press SHIFT, TAB to move backward. A mouse
can be used to move around the screen by pointing to a field and
clicking once. Within each field the direction, DELETE and INSERT keys
can be used to edit.
The program does not require fields to be edited when the data from the
previous record is the same as the current record you are entering.
Press TAB to skip to the next field without changing the current field
entry.
Each data entry field has built-in edit checking to verify valid
information was entered. For example, you cannot enter alpha characters
in the Cost field. A Data Entry Error dialog box will appear if an
invalid entry is made. Press ENTER to remove the dialog box.
10
Data Entry and Edit Command Buttons:
The command buttons at the bottom of the screen can be activated by
pointing to a button and clicking or pressing ALT and the key for the
underlined letter. Also, TAB can be used to move the highlight to a
button and pressing ENTER to activate that button.
Save a Record:
Mouse * Point to the Add button and click.
Keyboard * Press ALT, A.
This will save the record currently displayed on the screen. The cursor
will then be move to the Country field.
Editing Records
The Data Entry and Edit Screen is used also used to edit records in your
database.
Find a Record:
StampBase provides two ways to find records in a database file. If you
know the country that issued the stamp and/or the stamp's catalog
number, you can use the following method:
1. Move the cursor to the country and catalog number fields. Enter
the appropriate information.
2. Point to the Find button and click or press ALT, F.
3. StampBase will now search the file for the record you specified.
StampBase will display in the Data Entry and Edit Screen the first
record meeting the criteria.
The Find Record dialog box will appear if the record is not found.
Press ENTER to clear the dialog box from the screen. Attempt another
search if an error was made when entering the country or catalog number.
The second method for locating a record is "paging" through the database
one record at a time. Use the Next button to move forward through the
database. Use the Previous button to move backward.
Mouse * Point to the Next or Previous buttons and click to display
record on the screen.
Keyboard * Press Alt, N or P to display record on the screen.
11
You also can press TAB to highlight the Next or Previous buttons
and press ENTER.
Note: Next button - When you reach the last record in the database,
the Edit Record dialog box will appear. Press ENTER to clear the
dialog box from the screen. The next record displayed is the
last record in the database.
Previous button - When you reach the first record in the
database, the Edit Record dialog box will appear. Press ENTER to
clear the dialog box from the screen. The next record displayed
is the first record in the database.
Change a Record:
The Change button is used to save changes made to the record currently
displayed in the Data Entry and Edit Screen. After editing the record
do the following to save the change(s):
1. Point to the Change button and click or press ALT, C. The Edit
Record dialog box will appear requesting verification to save the
change(s).
2. Point to the YES button and click or press ENTER to save the
change(s). Point to the NO button and click or press TAB to
highlight the NO button and press ENTER to cancel the change(s).
Changes will be saved to disk when you exit from the Data Entry
and Edit Screen.
Delete a Record:
The Delete button is used to delete the record currently displayed in
the Data Entry and Edit Screen.
1. Point to the Delete button and click or press ALT, D. An Edit
Record dialog box will appear requesting verification.
2. Point to the YES button and click or press ENTER to mark the
record for deletion. Point to the NO button and click or press
ALT, A to cancel Delete.
If the record deletion was not cancelled, another Edit Record dialog box
will appear notifying you that the record is marked for deletion. Point
to the OK button and click or press ENTER to clear the dialog box. The
data entry fields will now be blank. See the instructions for Pack
Records to remove deleted record(s) from the database file.
Print a Record:
The Print button is used to print the record displayed in the Data Entry
and Edit Screen. Point to the Print button and click or press ALT, R to
print the record.
12
Exit the Data Entry and Edit Screen:
Point to the Exit button and click or press ALT, X to leave the Data
Entry and Edit Screen. Exiting from the Data Entry and Edit Screen will
save all additions, changes and deletions made to the database. You
will be returned to the StampBase menu bar. The database file will
require sorting if records are added. Sorting may be required if
changes are made to a record's country or catalog number fields.
Sort Records
StampBase sorts records first alphabetically by the country that issued the
stamp and secondly by the stamp's catalog number. The catalog numbers are
sorted using the numbering system used by most stamp catalogs and
publications.
Mouse 1. Point to Records on the menu bar and click to open the menu.
2. Point to Sort and click. The Sort Record screen will
appear.
3. Point to the Sort button and click to begin sorting the
database. The screen will display the sorting progress and
notify you when the sorting is done.
4. Point to the Exit button and click to exit the Sort screen.
The database file will be saved with the new sort order.
Keyboard 1. Press ALT, R to open the menu.
2. Press S. The Sort Record screen will appear.
3. Press ENTER to begin sorting. The screen will display the
sorting progress and notify you when the sorting is done.
4. Press TAB to highlight the Exit button and press ENTER to
exit the Sort screen. The database file will be saved with
the new sort order.
Pack Records
StampBase will remove record(s) marked for deletion by creating a temporary
file. Records not marked for deletion are copied to this temporary file. The
file containing the deleted records is erased. The temporary file's name is
changed to the erased file's name.
The temporary file created during record packing will be the same size as the
database file less the space used by deleted records. Make sure your hard
drive has enough space before you begin packing.
13
Mouse 1. Point to Records on the menu bar and click to open the menu.
2. Point to Pack and click. The Pack Records screen will
appear.
3. Point to the Pack button and click to begin removing deleted
records. The screen will display the packing progress and
notify you when the process is done.
4. Point to the Exit button and click to exit Pack Records.
The database file will be saved.
Keyboard 1. Press ALT, R to open the menu.
2. Press P. The Pack Records screen will appear.
3. Press ENTER to begin removing deleted records. The screen
will display the packing progress and notify you when the
process is done.
4. Press ALT, X to exit Pack Records. The database file will
be saved.
Saving Files
The database file is automatically saved when you exit from Update, Sort and
Pack.
14
CHAPTER 4 - REPORTS
Types of Reports
StampBase can generate two different reports that can be either displayed on
your computer screen or printed. The Stamp Inventory List will list the
records in sorted order. The Collection Analysis Report will show statistical
information about your stamp collection database. Reports are setup to print
on an 80 column printer.
Stamp Inventory List:
Display List on Screen
Mouse 1. Point to Reports on the menu bar and click to open the menu.
2. Point to the List Records menu item and click. The report
screen will appear.
3. Point to the Screen button and click. The List Records
dialog box will appear.
4. Point to the YES button and click to list all records in the
database. Point to the NO button and click to list the
stamps issued by a particular country.
a. If NO was selected, enter the country.
b. Point to the OK button and click to display the report or
point to the Cancel button and click to clear the dialog
box.
All or part of the records you selected will be displayed on
the screen. The first record in the database or the first
record for the country you specified above. A maximum of
twenty records can be displayed on the screen at once.
Scroll through the database by pointing to a Scroll button
and clicking.
The following buttons are used to scroll through the database:
Home - Scrolls to first record.
Up - Scrolls up one record.
Down - Scrolls down one record.
PgUp - Scrolls up one screen.
PgDn - Scrolls down one screen.
15
End - Scrolls to last record.
Keyboard 1. Press ALT, E to open the Report menu.
2. Press L. The Report screen will appear.
3. Press ENTER. The List Records dialog box will appear.
4. Press ENTER to list all records or TAB to highlight the NO
button and press ENTER to list the stamps issued by one
country.
a. If NO was selected, enter the country.
b. Press TAB to highlight the OK button and press ENTER to
display the report or press TAB to highlight the Cancel
button and press ENTER to clear the dialog box.
The following methods can be used to scroll through the
database:
1) Press TAB to highlight a Scroll button and press
ENTER.
2) Press ALT and letter underlined on the Scroll button.
(Example: ALT, E for the End button)
Print Report
Follow the same procedure for displaying records on the
screen except click or press the Printer button.
Exit List Records
Point to the Exit button or press TAB to highlight the Exit
button and press ENTER.
Collection Analysis Report:
Display Report on Screen
Mouse 1. Point to Reports on the menu bar and click to open the menu.
2. Point to the Analysis menu item and click. The Report
screen will appear.
3. Point to the Screen button and click. StampBase will
display the report on the screen after searching through the
database.
Keyboard 1. Press ALT, E to open the Records menu.
16
2. Press C. The Collection Analysis Report screen will appear.
3. Press ENTER and StampBase will display the report on the
screen.
Print Report
Follow the same procedure for displaying records on the screen
except click or press the Printer button.
Exit Collection Analysis Report
Point to the Exit button or press TAB to highlight the Exit button
and press ENTER.
17
CHAPTER 5 - TECHNICAL SUPPORT
I have attempted to design StampBase to be easy to use. Still, I will be
happy to help you if you encounter a problem. Contact me by one of the
following methods:
Telephone (608) 273-2739
Probably the best way to solve a problem. It is easier to provide
assistance when I can speak with you directly. Call me during the
following times:
Monday - Friday 7 - 9 PM
Saturday 9 AM - 4 PM
All times are Central Standard Time.
Please try to be in front of your computer with the program operating.
It is difficult to diagnose a software problem if you are not at the
computer.
CompuServe
ID number 71371,731
Write
Send correspondence to:
Mark L. Hetzel
4466 Sentinel Pass
Madison, WI 53711
Any comments or suggestions you have StampBase for Windows would be
appreciated.
18